package com.ruoyi.personnel.mapper;

import com.ruoyi.personnel.domain.Personnel;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.util.List;

@Repository
public interface PersonnelMapper {

    public List<Personnel> queryByPage(Personnel personnel);

    public Personnel getPersonnelById(@Param("id") int id);

    public Personnel getPersonnelByNo(@Param("no") String no);

    public int getCountByNo(@Param("id") int id, @Param("no") String no);

    public int insert(Personnel personnel);

    public int update(Personnel personnel);

    public int delByIds(@Param("ids") Long[] ids);

    public int getCountByJobNo(@Param("id") int id, @Param("jobNo") String jobNo);

    public List<Personnel> getListExcel(Personnel personnel);
}
